This report assists in balancing your bank deposit slip to the payments received on a given date. Before arriving at the View window, you will be asked the date you wish to reconcile. The Internal Date is defaulted.
A Calculate button will total the itemized break-out of all payments received. This is also true for the Printed report.
You can select another date by 'clicking' on the New Date Button or Cancel to return to the Reports Window
PAYMENT HISTORY AND PAY OFF REPORT
You first select a loan record for view. Again the payment history is in Scroll Box View. The 'As Of' date is an entry field that allows you to calulate a pay off for any date equal to or after the last payment date. Prepayment penalty will be considered for this calculation and interest is calculated at a daily rate and counting the number of days from the last payment date through the 'As Of' date entered.
Print to the immediate right of the calculate button will print the pay off information, original loan data, and payment history. This is the only report where the user adress is used since this printed report can be mailed to the borrower.
Print Loan History prints original loan data, a listing of Other Information (collateral) and Payment history with totals.
DELINQUENCY PAYMENT REPORT
The Internal Calender Date is the key that compares to the delinquency date which is the due date plus the number of days allowed before a late fee is charged. This is not a listing for view but each record separately. You can move from record to record using the NEXT or PREVIOUS buttons.
Comments regarding payment can be recorded here as well as temporarily changing the delinquency date to a pre-arranged date taking it off the report until the new date has arrived.
After the payment has been finally received, the deliquency date will be reset to the proper date. Comments are listed in reverse sequence, the most current first and cannot be deleted until the entire loan record is deleted.
Printing from any delinquency record prints a listing of all deliquencies showing loan number, name, phone number, deliquency date, late fee, and payment amount. You will return to the report window after printing.
PRINT ONLY
LOAN SUMMARY AND STATUS REPORT
You will first arrive at a sub-menu listing Loan Summary Report, Status Report, Underlying Loan Summary Report, Status Report. You will give a 'From' and 'Through' date for of these report before print.
Summary Reports also give you and added choice of Detail or Totals Only. Detail Lists each loan with activity for the period selected as well as grand totals. The totals only is just that, totals only for discounts earned, interest, late fees, prepay amounts principle, payment, and beginning and ending balances. These same items are subtotaled by loan on the detailed report.
Status Reports list in status order each loan, original loan amount, current loan amount, and payment and subtotals for each status code, i.e. A-Active, C-Collection, F-Foreclosure, L-Legal, P-Paid Off, and W-Write Off.
INSURANCE POLICY EXPIRATION-60 DAYS
The Internal Calender Date is the key that activates this report. If the insurance policy expires within 60 days of 'today', it will list.
BALLOON PAYMENT NEXT DUE DATE
The fact that the next payment is the last payment and the current loan balance is greater than the payment will trigger this report. It will list the loan number, name due date, telephone number and the current balance.
YEAR-END 1098 INFORMATION
A listing of all loans with payment activity in the year selected at the next window. Included is the loan number, name, address, social security number and interest plus prepayments paid, and a total of all interest paid. This report does NOT print directly to the 1098 form.
VIEW ONLY
BORROWER INFORMATION
All Entry or Scroll Box Listings are available for viewing after selecting a record. NO EDIT is available here, just Quick-View of an entire record.
General Information, original loan and underlying loan data, payments, co-signer, insurance, other information (collateral), escrow, and current loan balance adjustment can be seen just be clicking on the appropriate button.
